package com.bx.implatform.growUp.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

@Mapper
public interface SnowMapper {

    @Select("""
        SELECT
            "fgsName" AS x,
            SUM(${type}) AS y
        FROM
            "data_center"."snow_removal_investment"
        GROUP BY
            "fgsName"
        """)
    List<Map<String, Object>> floodSnow(String type);
}
